Tabela BenefitPlan

Definicja tabeli BenefitPlan

Name

BenefitPlan

Code

BenefitPlan

Comment

PL: Definicja benefitplanu
EN: Benefitplan definition table


Lista kolumn tabeli BenefitPlan

Name

Code

BenefitPlanID

BenefitPlanID

BenefitPlanGroupID

BenefitPlanGroupID

FullName

FullName

Static

Static

Code

Code

Notes

Notes

StartDT

StartDT

StopDT

StopDT

VIP

VIP


Kolumna BenefitPlanID tabeli BenefitPlan

Definicja kolumny BenefitPlanID tabeli BenefitPlan

Name

BenefitPlanID

Code

BenefitPlanID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna BenefitPlanGroupID tabeli BenefitPlan

Definicja kolumny BenefitPlanGroupID tabeli BenefitPlan

Name

BenefitPlanGroupID

Code

BenefitPlanGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FullName tabeli BenefitPlan

Definicja kolumny FullName tabeli BenefitPlan

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Static tabeli BenefitPlan

Definicja kolumny Static tabeli BenefitPlan

Name

Static

Code

Static

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Code tabeli BenefitPlan

Definicja kolumny Code tabeli BenefitPlan

Name

Code

Code

Code

Data Type

VARCHAR2(30)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna Notes tabeli BenefitPlan

Definicja kolumny Notes tabeli BenefitPlan

Name

Notes

Code

Notes

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna StartDT tabeli BenefitPlan

Definicja kolumny StartDT tabeli BenefitPlan

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli BenefitPlan

Definicja kolumny StopDT tabeli BenefitPlan

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna VIP tabeli BenefitPlan

Definicja kolumny VIP tabeli BenefitPlan

Name

VIP

Code

VIP

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli BenefitPlan

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli BenefitPlan

Definicja klucza Identifier_1 tabeli BenefitPlan

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment